CREATE TABLE `actividad` (`id_actividad` int(11) NOT NULL default '0',`descripcion` varchar(100) NOT NULL default '',PRIMARY KEY  (`id_actividad`),UNIQUE KEY `descripcion` (`descripcion`)) TYPE=InnoDB;
INSERT INTO actividad VALUES('4','Abrir papel de trabajo');
INSERT INTO actividad VALUES('7','Agregar nueva institucin');
INSERT INTO actividad VALUES('21','Agregar nuevo contacto');
INSERT INTO actividad VALUES('3','Agregar nuevo usuario');
INSERT INTO actividad VALUES('16','Cambiar datos de un papel');
INSERT INTO actividad VALUES('10','Cerrar papel');
INSERT INTO actividad VALUES('20','Consultar datos de contactos');
INSERT INTO actividad VALUES('6','Consultar datos de instituciones');
INSERT INTO actividad VALUES('2','Consultar datos de usuario');
INSERT INTO actividad VALUES('11','Consultar historial de usuario');
INSERT INTO actividad VALUES('17','Consultar plantillas creadas');
INSERT INTO actividad VALUES('8','Consultar preguntas de cdulas');
INSERT INTO actividad VALUES('5','Crear nuevo papel de trabajo');
INSERT INTO actividad VALUES('1','Entrada al sistema');
INSERT INTO actividad VALUES('19','Modificar datos de institucion');
INSERT INTO actividad VALUES('18','Modificar datos de usuario');
INSERT INTO actividad VALUES('0','Salir del sistema');
INSERT INTO actividad VALUES('12','Trabajar con la cdula de hardware');
INSERT INTO actividad VALUES('9','Trabajar con la cdula de planificacin');
INSERT INTO actividad VALUES('14','Trabajar con la cdula de polticas');
INSERT INTO actividad VALUES('15','Trabajar con la cdula de seguridad');
INSERT INTO actividad VALUES('13','Trabajar con la cdula de software');
CREATE TABLE `categoria` (`id_categoria` tinyint(3) unsigned NOT NULL default '0',`nom_categoria` varchar(30) NOT NULL default '',`id_ced` tinyint(3) unsigned NOT NULL default '0',PRIMARY KEY  (`id_categoria`),UNIQUE KEY `nom_categoria` (`nom_categoria`),KEY `id_ced` (`id_ced`)) TYPE=InnoDB;
INSERT INTO categoria VALUES('0','GeneralPlani','0');
INSERT INTO categoria VALUES('1','GeneralHard','1');
INSERT INTO categoria VALUES('2','GeneralSoft','2');
INSERT INTO categoria VALUES('3','GeneralPoli','3');
INSERT INTO categoria VALUES('4','Base de Datos','4');
INSERT INTO categoria VALUES('5','Contraseas','4');
INSERT INTO categoria VALUES('6','Seguridad fsica','4');
INSERT INTO categoria VALUES('7','Seguridad General','4');
CREATE TABLE `cedula` (`id_ced` tinyint(3) unsigned NOT NULL default '0',`nom_ced` enum('cplan','ch','cs','cpp','cse','cha','cm') NOT NULL default 'cplan',PRIMARY KEY  (`id_ced`),UNIQUE KEY `nom_ced` (`nom_ced`)) TYPE=InnoDB;
INSERT INTO cedula VALUES('0','cplan');
INSERT INTO cedula VALUES('1','ch');
INSERT INTO cedula VALUES('2','cs');
INSERT INTO cedula VALUES('3','cpp');
INSERT INTO cedula VALUES('4','cse');
INSERT INTO cedula VALUES('5','cha');
INSERT INTO cedula VALUES('6','cm');
CREATE TABLE `contacto` (`id_contact` int(10) unsigned NOT NULL default '0',`ape_contact` varchar(30) NOT NULL default '',`nom_contact` varchar(30) NOT NULL default '',`tel_contact` varchar(9) NOT NULL default '',`ema_contact` varchar(30) default NULL,`id_insti` varchar(5) NOT NULL default '',PRIMARY KEY  (`id_contact`),UNIQUE KEY `tel_contact` (`tel_contact`),UNIQUE KEY `ema_contact` (`ema_contact`),KEY `id_insti` (`id_insti`)) TYPE=InnoDB;
CREATE TABLE `bitacora` (`id_entrada` bigint(20) NOT NULL default '0',`id_usu` int(10) unsigned NOT NULL default '0',`id_actividad` int(11) NOT NULL default '0',`fecha` date NOT NULL default '0000-00-00',`hora` time NOT NULL default '00:00:00',PRIMARY KEY  (`id_entrada`),KEY `id_usu` (`id_usu`),KEY `id_actividad` (`id_actividad`)) TYPE=InnoDB;
INSERT INTO historial VALUES('0','1','1','2007-11-29','19:56:07');
INSERT INTO historial VALUES('1','2','0','2007-12-06','21:46:58');
INSERT INTO historial VALUES('2','2','0','2007-12-06','21:47:50');
INSERT INTO historial VALUES('3','2','0','2007-12-06','21:48:08');
INSERT INTO historial VALUES('4','2','1','2007-12-06','21:52:37');
INSERT INTO historial VALUES('5','2','0','2007-12-06','21:53:00');
INSERT INTO historial VALUES('6','2','1','2007-12-06','22:46:11');
INSERT INTO historial VALUES('7','2','4','2007-12-06','22:46:30');
INSERT INTO historial VALUES('8','2','0','2007-12-06','22:46:38');
INSERT INTO historial VALUES('9','2','1','2007-12-06','23:01:18');
INSERT INTO historial VALUES('10','2','4','2007-12-06','23:01:29');
INSERT INTO historial VALUES('11','2','9','2007-12-06','23:01:40');
INSERT INTO historial VALUES('12','2','9','2007-12-06','23:02:05');
INSERT INTO historial VALUES('13','2','12','2007-12-06','23:02:25');
INSERT INTO historial VALUES('14','2','12','2007-12-06','23:04:56');
INSERT INTO historial VALUES('15','2','12','2007-12-06','23:05:24');
INSERT INTO historial VALUES('16','2','12','2007-12-06','23:16:29');
INSERT INTO historial VALUES('17','2','13','2007-12-06','23:22:35');
INSERT INTO historial VALUES('18','2','14','2007-12-06','23:22:46');
INSERT INTO historial VALUES('19','2','12','2007-12-06','23:23:01');
INSERT INTO historial VALUES('20','2','12','2007-12-06','23:36:54');
INSERT INTO historial VALUES('21','2','12','2007-12-06','23:42:24');
INSERT INTO historial VALUES('22','2','13','2007-12-06','23:42:32');
INSERT INTO historial VALUES('23','2','14','2007-12-06','23:42:53');
INSERT INTO historial VALUES('24','2','15','2007-12-06','23:43:30');
INSERT INTO historial VALUES('25','2','15','2007-12-06','23:43:48');
INSERT INTO historial VALUES('26','2','9','2007-12-06','23:44:11');
INSERT INTO historial VALUES('27','2','12','2007-12-06','23:44:16');
INSERT INTO historial VALUES('28','2','12','2007-12-06','23:44:53');
INSERT INTO historial VALUES('29','2','13','2007-12-06','23:45:07');
INSERT INTO historial VALUES('30','2','14','2007-12-06','23:45:20');
INSERT INTO historial VALUES('31','2','15','2007-12-06','23:45:29');
INSERT INTO historial VALUES('32','2','15','2007-12-06','23:53:02');
INSERT INTO historial VALUES('33','2','0','2007-12-07','03:21:26');
INSERT INTO historial VALUES('34','2','1','2007-12-07','03:41:40');
INSERT INTO historial VALUES('35','2','4','2007-12-07','03:41:51');
INSERT INTO historial VALUES('36','2','9','2007-12-07','03:42:06');
INSERT INTO historial VALUES('37','2','1','2007-12-07','08:31:23');
INSERT INTO historial VALUES('38','2','4','2007-12-07','08:31:30');
INSERT INTO historial VALUES('39','2','9','2007-12-07','08:31:36');
INSERT INTO historial VALUES('40','2','9','2007-12-07','08:31:42');
INSERT INTO historial VALUES('41','2','0','2007-12-07','13:43:19');
INSERT INTO historial VALUES('42','2','1','2007-12-07','18:59:46');
INSERT INTO historial VALUES('43','2','4','2007-12-07','19:00:41');
INSERT INTO historial VALUES('44','2','9','2007-12-07','19:00:53');
INSERT INTO historial VALUES('45','2','9','2007-12-07','19:01:11');
INSERT INTO historial VALUES('46','1','1','2007-12-07','22:06:56');
INSERT INTO historial VALUES('47','1','0','2007-12-07','22:07:04');
INSERT INTO historial VALUES('48','2','1','2007-12-07','22:07:16');
INSERT INTO historial VALUES('49','2','4','2007-12-07','22:07:23');
INSERT INTO historial VALUES('50','2','9','2007-12-07','22:07:31');
INSERT INTO historial VALUES('51','2','1','2007-12-08','00:09:55');
INSERT INTO historial VALUES('52','2','4','2007-12-08','00:10:07');
INSERT INTO historial VALUES('53','2','9','2007-12-08','00:10:14');
INSERT INTO historial VALUES('54','2','16','2007-12-08','01:04:35');
INSERT INTO historial VALUES('55','2','16','2007-12-08','01:08:21');
INSERT INTO historial VALUES('56','2','0','2007-12-08','01:08:28');
INSERT INTO historial VALUES('57','3','1','2007-12-08','01:08:41');
INSERT INTO historial VALUES('58','3','4','2007-12-08','01:08:46');
INSERT INTO historial VALUES('59','3','9','2007-12-08','01:08:52');
INSERT INTO historial VALUES('60','3','16','2007-12-08','01:08:58');
INSERT INTO historial VALUES('61','3','10','2007-12-08','01:09:17');
INSERT INTO historial VALUES('62','3','1','2007-12-08','01:09:18');
INSERT INTO historial VALUES('63','3','0','2007-12-08','01:09:27');
INSERT INTO historial VALUES('64','1','1','2007-12-08','01:15:51');
INSERT INTO historial VALUES('65','1','0','2007-12-08','01:16:03');
INSERT INTO historial VALUES('66','2','1','2007-12-08','01:18:19');
INSERT INTO historial VALUES('67','2','17','2007-12-08','01:18:32');
INSERT INTO historial VALUES('68','2','4','2007-12-08','01:18:43');
INSERT INTO historial VALUES('69','2','9','2007-12-08','01:18:55');
INSERT INTO historial VALUES('70','2','0','2007-12-08','03:12:49');
INSERT INTO historial VALUES('71','1','1','2007-12-09','06:56:42');
INSERT INTO historial VALUES('72','1','0','2007-12-09','23:41:22');
INSERT INTO historial VALUES('73','1','1','2007-12-09','23:44:57');
INSERT INTO historial VALUES('74','1','4','2007-12-09','23:45:03');
INSERT INTO historial VALUES('75','1','9','2007-12-09','23:45:10');
INSERT INTO historial VALUES('76','1','10','2007-12-09','23:45:30');
INSERT INTO historial VALUES('77','1','1','2007-12-09','23:45:32');
INSERT INTO historial VALUES('78','1','0','2007-12-09','23:45:35');
INSERT INTO historial VALUES('79','1','1','2007-12-09','23:46:20');
INSERT INTO historial VALUES('80','1','4','2007-12-09','23:46:36');
INSERT INTO historial VALUES('81','1','9','2007-12-09','23:46:41');
INSERT INTO historial VALUES('82','1','1','2007-12-09','23:52:36');
INSERT INTO historial VALUES('83','1','4','2007-12-09','23:52:42');
INSERT INTO historial VALUES('84','1','9','2007-12-09','23:52:47');
INSERT INTO historial VALUES('85','1','0','2007-12-09','23:53:28');
INSERT INTO historial VALUES('86','2','1','2007-12-10','00:40:11');
INSERT INTO historial VALUES('87','2','4','2007-12-10','00:40:18');
INSERT INTO historial VALUES('88','2','9','2007-12-10','00:40:24');
INSERT INTO historial VALUES('89','2','1','2007-12-10','05:33:52');
INSERT INTO historial VALUES('90','2','4','2007-12-10','05:33:59');
INSERT INTO historial VALUES('91','2','9','2007-12-10','05:34:05');
INSERT INTO historial VALUES('92','2','16','2007-12-10','06:27:04');
INSERT INTO historial VALUES('93','2','14','2007-12-10','06:27:11');
INSERT INTO historial VALUES('94','2','12','2007-12-10','06:28:06');
INSERT INTO historial VALUES('95','2','9','2007-12-10','06:28:10');
INSERT INTO historial VALUES('96','2','9','2007-12-10','06:28:14');
INSERT INTO historial VALUES('97','2','0','2007-12-10','06:28:28');
INSERT INTO historial VALUES('98','2','1','2007-12-10','06:29:28');
INSERT INTO historial VALUES('99','2','4','2007-12-10','06:29:35');
INSERT INTO historial VALUES('100','2','9','2007-12-10','06:29:41');
INSERT INTO historial VALUES('101','2','9','2007-12-10','06:29:48');
INSERT INTO historial VALUES('102','2','9','2007-12-10','06:31:20');
INSERT INTO historial VALUES('103','2','9','2007-12-10','06:32:25');
INSERT INTO historial VALUES('104','2','9','2007-12-10','06:39:37');
INSERT INTO historial VALUES('105','2','9','2007-12-10','06:46:31');
INSERT INTO historial VALUES('106','2','9','2007-12-10','06:55:22');
INSERT INTO historial VALUES('107','2','9','2007-12-10','06:56:24');
INSERT INTO historial VALUES('108','2','9','2007-12-10','06:56:44');
INSERT INTO historial VALUES('109','2','9','2007-12-10','06:57:02');
INSERT INTO historial VALUES('110','2','9','2007-12-10','06:58:04');
INSERT INTO historial VALUES('111','2','9','2007-12-10','06:59:05');
INSERT INTO historial VALUES('112','2','9','2007-12-10','07:03:08');
INSERT INTO historial VALUES('113','2','9','2007-12-10','07:05:05');
INSERT INTO historial VALUES('114','2','9','2007-12-10','07:07:30');
INSERT INTO historial VALUES('115','2','9','2007-12-10','07:13:38');
INSERT INTO historial VALUES('116','2','9','2007-12-10','07:15:43');
INSERT INTO historial VALUES('117','2','9','2007-12-10','07:18:52');
INSERT INTO historial VALUES('118','2','9','2007-12-10','07:21:47');
INSERT INTO historial VALUES('119','2','9','2007-12-10','07:23:17');
INSERT INTO historial VALUES('120','2','9','2007-12-10','07:24:45');
INSERT INTO historial VALUES('121','2','9','2007-12-10','07:47:47');
INSERT INTO historial VALUES('122','2','9','2007-12-10','08:07:19');
INSERT INTO historial VALUES('123','2','9','2007-12-10','08:10:37');
INSERT INTO historial VALUES('124','2','9','2007-12-10','08:13:48');
INSERT INTO historial VALUES('125','2','9','2007-12-10','08:14:46');
INSERT INTO historial VALUES('126','2','9','2007-12-10','08:15:54');
INSERT INTO historial VALUES('127','2','9','2007-12-10','08:16:24');
INSERT INTO historial VALUES('128','2','9','2007-12-10','08:23:20');
INSERT INTO historial VALUES('129','2','9','2007-12-10','08:24:10');
INSERT INTO historial VALUES('130','2','9','2007-12-10','08:24:41');
INSERT INTO historial VALUES('131','2','9','2007-12-10','08:25:09');
INSERT INTO historial VALUES('132','2','9','2007-12-10','08:26:08');
INSERT INTO historial VALUES('133','2','9','2007-12-10','08:30:52');
INSERT INTO historial VALUES('134','2','9','2007-12-10','08:31:24');
INSERT INTO historial VALUES('135','2','9','2007-12-10','08:31:45');
INSERT INTO historial VALUES('136','2','9','2007-12-10','08:32:02');
INSERT INTO historial VALUES('137','2','9','2007-12-10','08:32:15');
INSERT INTO historial VALUES('138','2','9','2007-12-10','08:32:54');
INSERT INTO historial VALUES('139','2','9','2007-12-10','08:33:12');
INSERT INTO historial VALUES('140','2','9','2007-12-10','08:33:28');
INSERT INTO historial VALUES('141','2','9','2007-12-10','08:36:23');
INSERT INTO historial VALUES('142','2','9','2007-12-10','08:38:39');
INSERT INTO historial VALUES('143','2','9','2007-12-10','08:41:29');
INSERT INTO historial VALUES('144','2','9','2007-12-10','08:41:45');
INSERT INTO historial VALUES('145','2','9','2007-12-10','08:43:37');
INSERT INTO historial VALUES('146','2','9','2007-12-10','08:45:19');
INSERT INTO historial VALUES('147','2','9','2007-12-10','08:48:53');
INSERT INTO historial VALUES('148','2','9','2007-12-10','08:52:54');
INSERT INTO historial VALUES('149','2','9','2007-12-10','08:53:57');
INSERT INTO historial VALUES('150','2','9','2007-12-10','08:55:24');
INSERT INTO historial VALUES('151','2','9','2007-12-10','08:59:15');
INSERT INTO historial VALUES('152','2','9','2007-12-10','09:00:33');
INSERT INTO historial VALUES('153','2','9','2007-12-10','09:01:26');
INSERT INTO historial VALUES('154','2','9','2007-12-10','09:21:30');
INSERT INTO historial VALUES('155','2','9','2007-12-10','09:22:39');
INSERT INTO historial VALUES('156','2','9','2007-12-10','09:30:08');
INSERT INTO historial VALUES('157','2','9','2007-12-10','09:31:19');
INSERT INTO historial VALUES('158','2','9','2007-12-10','09:33:39');
INSERT INTO historial VALUES('159','2','9','2007-12-10','09:35:20');
INSERT INTO historial VALUES('160','2','9','2007-12-10','09:46:49');
INSERT INTO historial VALUES('161','2','9','2007-12-10','09:47:18');
INSERT INTO historial VALUES('162','2','9','2007-12-10','09:47:53');
INSERT INTO historial VALUES('163','2','9','2007-12-10','09:48:38');
INSERT INTO historial VALUES('164','2','9','2007-12-10','09:49:04');
INSERT INTO historial VALUES('165','2','9','2007-12-10','09:51:06');
INSERT INTO historial VALUES('166','2','9','2007-12-10','09:52:44');
INSERT INTO historial VALUES('167','2','9','2007-12-10','09:53:26');
INSERT INTO historial VALUES('168','2','9','2007-12-10','09:53:48');
INSERT INTO historial VALUES('169','2','9','2007-12-10','09:55:04');
INSERT INTO historial VALUES('170','2','9','2007-12-10','10:09:12');
INSERT INTO historial VALUES('171','2','9','2007-12-10','10:10:40');
INSERT INTO historial VALUES('172','2','9','2007-12-10','10:12:56');
INSERT INTO historial VALUES('173','2','9','2007-12-10','10:14:53');
INSERT INTO historial VALUES('174','2','9','2007-12-10','10:15:42');
INSERT INTO historial VALUES('175','2','9','2007-12-10','10:23:53');
INSERT INTO historial VALUES('176','2','9','2007-12-10','10:25:57');
INSERT INTO historial VALUES('177','2','9','2007-12-10','10:30:47');
INSERT INTO historial VALUES('178','2','9','2007-12-10','10:50:45');
INSERT INTO historial VALUES('179','2','9','2007-12-10','10:52:20');
INSERT INTO historial VALUES('180','2','9','2007-12-10','10:53:04');
INSERT INTO historial VALUES('181','2','9','2007-12-10','10:54:11');
INSERT INTO historial VALUES('182','2','9','2007-12-10','10:58:18');
INSERT INTO historial VALUES('183','2','9','2007-12-10','11:01:51');
INSERT INTO historial VALUES('184','2','9','2007-12-10','11:02:45');
INSERT INTO historial VALUES('185','2','10','2007-12-10','11:09:13');
INSERT INTO historial VALUES('186','2','1','2007-12-10','11:09:15');
INSERT INTO historial VALUES('187','2','0','2007-12-10','11:09:18');
INSERT INTO historial VALUES('188','1','1','2007-12-10','11:09:30');
INSERT INTO historial VALUES('189','1','0','2007-12-10','11:09:35');
INSERT INTO historial VALUES('190','2','1','2007-12-10','11:09:52');
INSERT INTO historial VALUES('191','2','4','2007-12-10','11:12:25');
INSERT INTO historial VALUES('192','2','9','2007-12-10','11:12:31');
INSERT INTO historial VALUES('193','2','9','2007-12-10','11:12:50');
INSERT INTO historial VALUES('194','2','0','2007-12-10','11:22:05');
INSERT INTO historial VALUES('195','1','1','2007-12-10','11:22:17');
INSERT INTO historial VALUES('196','1','0','2007-12-10','11:32:37');
INSERT INTO historial VALUES('197','1','1','2007-12-10','11:32:55');
INSERT INTO historial VALUES('198','1','4','2007-12-10','11:33:02');
INSERT INTO historial VALUES('199','1','9','2007-12-10','11:33:06');
INSERT INTO historial VALUES('200','1','0','2007-12-10','11:33:09');
INSERT INTO historial VALUES('201','2','1','2007-12-10','11:39:52');
INSERT INTO historial VALUES('202','2','0','2007-12-10','11:39:56');
INSERT INTO historial VALUES('203','1','1','2007-12-10','11:43:51');
INSERT INTO historial VALUES('204','1','2','2007-12-10','11:44:05');
INSERT INTO historial VALUES('205','1','18','2007-12-10','11:44:16');
INSERT INTO historial VALUES('206','1','2','2007-12-10','11:44:41');
INSERT INTO historial VALUES('207','1','0','2007-12-10','11:44:44');
INSERT INTO historial VALUES('208','1','1','2007-12-10','11:45:36');
INSERT INTO historial VALUES('209','1','2','2007-12-10','11:45:43');
INSERT INTO historial VALUES('210','1','18','2007-12-10','11:45:53');
INSERT INTO historial VALUES('211','1','2','2007-12-10','11:46:18');
INSERT INTO historial VALUES('212','1','18','2007-12-10','11:46:34');
INSERT INTO historial VALUES('213','1','2','2007-12-10','11:46:51');
INSERT INTO historial VALUES('214','1','3','2007-12-10','11:49:32');
INSERT INTO historial VALUES('215','1','2','2007-12-10','11:49:40');
INSERT INTO historial VALUES('216','1','18','2007-12-10','11:49:44');
INSERT INTO historial VALUES('217','1','2','2007-12-10','11:50:12');
INSERT INTO historial VALUES('218','1','0','2007-12-10','11:50:22');
INSERT INTO historial VALUES('219','2','1','2007-12-10','11:50:34');
INSERT INTO historial VALUES('220','2','0','2007-12-10','11:50:40');
INSERT INTO historial VALUES('221','2','1','2007-12-10','11:51:28');
INSERT INTO historial VALUES('222','2','4','2007-12-10','11:51:33');
INSERT INTO historial VALUES('223','2','9','2007-12-10','11:51:39');
INSERT INTO historial VALUES('224','2','9','2007-12-10','11:51:44');
INSERT INTO historial VALUES('225','2','0','2007-12-10','12:01:59');
INSERT INTO historial VALUES('226','2','1','2007-12-10','12:20:21');
INSERT INTO historial VALUES('227','2','4','2007-12-10','12:20:25');
INSERT INTO historial VALUES('228','2','9','2007-12-10','12:20:30');
INSERT INTO historial VALUES('229','2','9','2007-12-10','12:21:08');
INSERT INTO historial VALUES('230','2','9','2007-12-10','12:21:26');
INSERT INTO historial VALUES('231','2','9','2007-12-10','12:21:56');
INSERT INTO historial VALUES('232','2','9','2007-12-10','12:22:12');
INSERT INTO historial VALUES('233','2','9','2007-12-10','12:22:34');
INSERT INTO historial VALUES('234','2','9','2007-12-10','12:23:02');
INSERT INTO historial VALUES('235','2','9','2007-12-10','12:23:40');
INSERT INTO historial VALUES('236','2','9','2007-12-10','12:23:54');
INSERT INTO historial VALUES('237','2','9','2007-12-10','12:25:13');
INSERT INTO historial VALUES('238','2','9','2007-12-10','12:26:07');
INSERT INTO historial VALUES('239','2','9','2007-12-10','12:26:24');
INSERT INTO historial VALUES('240','2','9','2007-12-10','12:28:19');
INSERT INTO historial VALUES('241','2','0','2007-12-10','12:30:19');
INSERT INTO historial VALUES('242','1','1','2007-12-10','12:35:17');
INSERT INTO historial VALUES('243','1','6','2007-12-10','12:35:25');
INSERT INTO historial VALUES('244','1','19','2007-12-10','12:35:28');
INSERT INTO historial VALUES('245','1','6','2007-12-10','12:35:37');
INSERT INTO historial VALUES('246','1','0','2007-12-10','12:35:41');
INSERT INTO historial VALUES('247','2','1','2007-12-10','12:35:56');
INSERT INTO historial VALUES('248','2','4','2007-12-10','12:36:02');
INSERT INTO historial VALUES('249','2','9','2007-12-10','12:36:08');
INSERT INTO historial VALUES('250','2','0','2007-12-10','12:36:24');
INSERT INTO historial VALUES('251','2','1','2007-12-10','12:36:35');
INSERT INTO historial VALUES('252','2','4','2007-12-10','12:36:41');
INSERT INTO historial VALUES('253','2','0','2007-12-10','12:37:52');
INSERT INTO historial VALUES('254','1','1','2007-12-10','12:38:04');
INSERT INTO historial VALUES('255','1','6','2007-12-10','12:38:14');
INSERT INTO historial VALUES('256','1','19','2007-12-10','12:38:20');
INSERT INTO historial VALUES('257','1','6','2007-12-10','12:38:30');
INSERT INTO historial VALUES('258','1','19','2007-12-10','12:41:54');
INSERT INTO historial VALUES('259','1','6','2007-12-10','12:42:05');
INSERT INTO historial VALUES('260','1','19','2007-12-10','12:42:12');
INSERT INTO historial VALUES('261','1','6','2007-12-10','12:42:22');
INSERT INTO historial VALUES('262','1','0','2007-12-10','12:45:45');
INSERT INTO historial VALUES('263','2','1','2007-12-10','12:46:06');
INSERT INTO historial VALUES('264','2','4','2007-12-10','12:46:11');
INSERT INTO historial VALUES('265','2','0','2007-12-10','12:46:49');
INSERT INTO historial VALUES('266','2','1','2007-12-10','12:47:07');
INSERT INTO historial VALUES('267','2','4','2007-12-10','12:47:11');
INSERT INTO historial VALUES('268','2','4','2007-12-10','12:49:58');
INSERT INTO historial VALUES('269','2','4','2007-12-10','12:51:03');
INSERT INTO historial VALUES('270','2','4','2007-12-10','12:51:25');
INSERT INTO historial VALUES('271','2','0','2007-12-10','12:51:30');
INSERT INTO historial VALUES('272','1','1','2007-12-10','12:51:44');
INSERT INTO historial VALUES('273','1','4','2007-12-10','12:51:53');
INSERT INTO historial VALUES('274','1','6','2007-12-10','12:52:05');
INSERT INTO historial VALUES('275','1','19','2007-12-10','12:52:09');
INSERT INTO historial VALUES('276','1','6','2007-12-10','12:52:17');
INSERT INTO historial VALUES('277','1','0','2007-12-10','12:52:21');
INSERT INTO historial VALUES('278','2','1','2007-12-10','12:52:35');
INSERT INTO historial VALUES('279','2','4','2007-12-10','12:52:41');
INSERT INTO historial VALUES('280','2','4','2007-12-10','12:53:03');
INSERT INTO historial VALUES('281','2','4','2007-12-10','12:53:50');
INSERT INTO historial VALUES('282','2','0','2007-12-10','12:53:57');
INSERT INTO historial VALUES('283','3','1','2007-12-10','12:54:08');
INSERT INTO historial VALUES('284','3','4','2007-12-10','12:54:12');
INSERT INTO historial VALUES('285','3','0','2007-12-10','12:54:15');
INSERT INTO historial VALUES('286','1','1','2007-12-10','12:54:25');
INSERT INTO historial VALUES('287','1','0','2007-12-10','12:54:29');
INSERT INTO historial VALUES('288','1','1','2007-12-10','12:54:41');
INSERT INTO historial VALUES('289','1','4','2007-12-10','12:54:50');
INSERT INTO historial VALUES('290','1','6','2007-12-10','12:54:54');
INSERT INTO historial VALUES('291','1','19','2007-12-10','12:54:58');
INSERT INTO historial VALUES('292','1','6','2007-12-10','12:55:07');
INSERT INTO historial VALUES('293','1','20','2007-12-10','12:55:12');
INSERT INTO historial VALUES('294','1','20','2007-12-10','12:55:50');
INSERT INTO historial VALUES('295','1','20','2007-12-10','12:56:09');
INSERT INTO historial VALUES('296','1','21','2007-12-10','12:56:13');
INSERT INTO historial VALUES('297','1','21','2007-12-10','12:56:40');
INSERT INTO historial VALUES('298','1','21','2007-12-10','12:57:04');
INSERT INTO historial VALUES('299','1','0','2007-12-10','12:57:11');
INSERT INTO historial VALUES('300','1','1','2007-12-12','12:42:07');
INSERT INTO historial VALUES('301','1','4','2007-12-12','12:42:27');
INSERT INTO historial VALUES('302','1','6','2007-12-12','12:42:35');
INSERT INTO historial VALUES('303','1','19','2007-12-12','12:42:40');
INSERT INTO historial VALUES('304','1','6','2007-12-12','12:42:50');
INSERT INTO historial VALUES('305','1','7','2007-12-12','12:42:55');
INSERT INTO historial VALUES('306','1','4','2007-12-12','12:43:02');
INSERT INTO historial VALUES('307','1','9','2007-12-12','12:43:07');
INSERT INTO historial VALUES('308','1','12','2007-12-12','12:43:14');
INSERT INTO historial VALUES('309','1','1','2007-12-12','13:00:32');
INSERT INTO historial VALUES('310','1','4','2007-12-12','13:00:53');
INSERT INTO historial VALUES('311','1','9','2007-12-12','13:01:03');
INSERT INTO historial VALUES('312','1','1','2007-12-12','05:25:32');
INSERT INTO historial VALUES('313','1','4','2007-12-12','05:25:52');
INSERT INTO historial VALUES('314','1','9','2007-12-12','05:26:00');
INSERT INTO historial VALUES('315','1','1','2007-12-12','05:48:04');
INSERT INTO historial VALUES('316','1','4','2007-12-12','05:57:55');
INSERT INTO historial VALUES('317','1','9','2007-12-12','05:58:02');
INSERT INTO historial VALUES('318','1','1','2007-12-12','06:48:42');
INSERT INTO historial VALUES('319','1','1','2007-12-12','06:49:21');
INSERT INTO historial VALUES('320','1','4','2007-12-12','06:49:31');
INSERT INTO historial VALUES('321','1','9','2007-12-12','06:49:38');
INSERT INTO historial VALUES('322','1','10','2007-12-12','06:51:43');
INSERT INTO historial VALUES('323','1','1','2007-12-12','06:51:45');
INSERT INTO historial VALUES('324','1','2','2007-12-12','06:51:50');
INSERT INTO historial VALUES('325','1','2','2007-12-12','06:56:10');
INSERT INTO historial VALUES('326','1','1','2007-12-12','07:28:21');
INSERT INTO historial VALUES('327','1','2','2007-12-12','07:28:44');
CREATE TABLE `institucion` (`id_insti` varchar(5) NOT NULL default '',`nom_insti` varchar(40) NOT NULL default '',`id_tipoinsti` tinyint(3) unsigned NOT NULL default '0',`dir_insti` varchar(50) NOT NULL default '',`tel_insti` varchar(9) NOT NULL default '',`estado` tinyint(4) NOT NULL default '1',PRIMARY KEY  (`id_insti`),UNIQUE KEY `nom_insti` (`nom_insti`),UNIQUE KEY `dir_insti` (`dir_insti`),UNIQUE KEY `tel_insti` (`tel_insti`),KEY `id_tipoinsti` (`id_tipoinsti`)) TYPE=InnoDB;
INSERT INTO institucion VALUES('011','Almacenadora Salvadorea SA de CV','0','San Salvador 1','2145-8965','1');
CREATE TABLE `papel_de_trabajo` (`id_papel` bigint(20) unsigned NOT NULL default '0',`nom_papel` varchar(30) NOT NULL default '',`fech_creac` date NOT NULL default '0000-00-00',`fech_actua` date NOT NULL default '0000-00-00',`id_insti` varchar(5) NOT NULL default '',`descrip` text,`id_plantilla` bigint(20) unsigned NOT NULL default '0',PRIMARY KEY  (`id_papel`),UNIQUE KEY `nom_papel` (`nom_papel`),KEY `id_insti` (`id_insti`),KEY `id_plantilla` (`id_plantilla`)) TYPE=InnoDB;
INSERT INTO papel_de_trabajo VALUES('1','primer papel','0000-00-00','2007-12-12','011','papel de ejemplo','0');
CREATE TABLE `plantilla` (`id_plantilla` bigint(20) unsigned NOT NULL default '0',`nom_plantilla` varchar(30) NOT NULL default '',`id_usu` int(10) unsigned NOT NULL default '0',PRIMARY KEY  (`id_plantilla`),UNIQUE KEY `nom_plantilla` (`nom_plantilla`),KEY `id_usu` (`id_usu`)) TYPE=InnoDB;
INSERT INTO plantilla VALUES('0','GeneralAlmacenes','0');
INSERT INTO plantilla VALUES('1','GeneralBolsa','0');
INSERT INTO plantilla VALUES('2','GeneralCasas','0');
INSERT INTO plantilla VALUES('3','GeneralCedeval','0');
CREATE TABLE `preg_papel` (`id_preg` bigint(20) unsigned NOT NULL default '0',`id_papel` bigint(20) unsigned NOT NULL default '0',`resp` enum('si','no','na') default NULL,`obser` text,`causa` text NOT NULL,`efecto` text NOT NULL,KEY `id_preg` (`id_preg`),KEY `id_papel` (`id_papel`)) TYPE=InnoDB;
INSERT INTO preg_papel VALUES('31','1','si','libro 2','Esta bien','');
INSERT INTO preg_papel VALUES('43','1','no','libro 3','Esta mal','causa 1 del problema');
INSERT INTO preg_papel VALUES('32','1','si','Est bien','Est mal','');
INSERT INTO preg_papel VALUES('33','1','no','Ninguna','Est mal','causa 2');
INSERT INTO preg_papel VALUES('34','1','in','Ninguna','Est incompleto','causa 3');
INSERT INTO preg_papel VALUES('35','1','si','libro 3','Est bien','');
CREATE TABLE `preg_plantilla` (`id_preg` bigint(20) unsigned NOT NULL default '0',`id_plantilla` bigint(20) unsigned default NULL,KEY `id_preg` (`id_preg`),KEY `id_plantilla` (`id_plantilla`)) TYPE=InnoDB;
INSERT INTO preg_plantilla VALUES('1','0');
INSERT INTO preg_plantilla VALUES('1','1');
INSERT INTO preg_plantilla VALUES('1','2');
INSERT INTO preg_plantilla VALUES('1','3');
INSERT INTO preg_plantilla VALUES('2','0');
INSERT INTO preg_plantilla VALUES('2','1');
INSERT INTO preg_plantilla VALUES('2','2');
INSERT INTO preg_plantilla VALUES('2','3');
INSERT INTO preg_plantilla VALUES('3','0');
INSERT INTO preg_plantilla VALUES('3','1');
INSERT INTO preg_plantilla VALUES('3','2');
INSERT INTO preg_plantilla VALUES('3','3');
INSERT INTO preg_plantilla VALUES('4','0');
INSERT INTO preg_plantilla VALUES('5','0');
INSERT INTO preg_plantilla VALUES('5','1');
INSERT INTO preg_plantilla VALUES('5','2');
INSERT INTO preg_plantilla VALUES('5','3');
INSERT INTO preg_plantilla VALUES('6','0');
INSERT INTO preg_plantilla VALUES('6','1');
INSERT INTO preg_plantilla VALUES('6','2');
INSERT INTO preg_plantilla VALUES('6','3');
INSERT INTO preg_plantilla VALUES('7','0');
INSERT INTO preg_plantilla VALUES('7','1');
INSERT INTO preg_plantilla VALUES('7','2');
INSERT INTO preg_plantilla VALUES('7','3');
INSERT INTO preg_plantilla VALUES('8','0');
INSERT INTO preg_plantilla VALUES('8','1');
INSERT INTO preg_plantilla VALUES('8','2');
INSERT INTO preg_plantilla VALUES('8','3');
INSERT INTO preg_plantilla VALUES('9','0');
INSERT INTO preg_plantilla VALUES('9','1');
INSERT INTO preg_plantilla VALUES('9','2');
INSERT INTO preg_plantilla VALUES('9','3');
INSERT INTO preg_plantilla VALUES('10','0');
INSERT INTO preg_plantilla VALUES('10','1');
INSERT INTO preg_plantilla VALUES('10','3');
INSERT INTO preg_plantilla VALUES('11','0');
INSERT INTO preg_plantilla VALUES('12','0');
INSERT INTO preg_plantilla VALUES('12','1');
INSERT INTO preg_plantilla VALUES('12','2');
INSERT INTO preg_plantilla VALUES('12','3');
INSERT INTO preg_plantilla VALUES('13','0');
INSERT INTO preg_plantilla VALUES('14','0');
INSERT INTO preg_plantilla VALUES('15','0');
INSERT INTO preg_plantilla VALUES('16','0');
INSERT INTO preg_plantilla VALUES('16','1');
INSERT INTO preg_plantilla VALUES('16','2');
INSERT INTO preg_plantilla VALUES('16','3');
INSERT INTO preg_plantilla VALUES('17','0');
INSERT INTO preg_plantilla VALUES('17','1');
INSERT INTO preg_plantilla VALUES('17','2');
INSERT INTO preg_plantilla VALUES('17','3');
INSERT INTO preg_plantilla VALUES('18','0');
INSERT INTO preg_plantilla VALUES('18','1');
INSERT INTO preg_plantilla VALUES('18','2');
INSERT INTO preg_plantilla VALUES('18','3');
INSERT INTO preg_plantilla VALUES('19','2');
INSERT INTO preg_plantilla VALUES('20','2');
INSERT INTO preg_plantilla VALUES('21','2');
INSERT INTO preg_plantilla VALUES('23','0');
INSERT INTO preg_plantilla VALUES('23','1');
INSERT INTO preg_plantilla VALUES('23','2');
INSERT INTO preg_plantilla VALUES('23','3');
INSERT INTO preg_plantilla VALUES('24','3');
INSERT INTO preg_plantilla VALUES('25','3');
INSERT INTO preg_plantilla VALUES('26','3');
INSERT INTO preg_plantilla VALUES('27','1');
INSERT INTO preg_plantilla VALUES('28','1');
INSERT INTO preg_plantilla VALUES('29','1');
INSERT INTO preg_plantilla VALUES('30','1');
INSERT INTO preg_plantilla VALUES('31','0');
INSERT INTO preg_plantilla VALUES('31','1');
INSERT INTO preg_plantilla VALUES('31','2');
INSERT INTO preg_plantilla VALUES('31','3');
INSERT INTO preg_plantilla VALUES('32','0');
INSERT INTO preg_plantilla VALUES('32','1');
INSERT INTO preg_plantilla VALUES('32','2');
INSERT INTO preg_plantilla VALUES('32','3');
INSERT INTO preg_plantilla VALUES('33','0');
INSERT INTO preg_plantilla VALUES('33','1');
INSERT INTO preg_plantilla VALUES('33','2');
INSERT INTO preg_plantilla VALUES('33','3');
INSERT INTO preg_plantilla VALUES('34','0');
INSERT INTO preg_plantilla VALUES('34','1');
INSERT INTO preg_plantilla VALUES('34','2');
INSERT INTO preg_plantilla VALUES('34','3');
INSERT INTO preg_plantilla VALUES('35','0');
INSERT INTO preg_plantilla VALUES('35','1');
INSERT INTO preg_plantilla VALUES('35','2');
INSERT INTO preg_plantilla VALUES('35','3');
INSERT INTO preg_plantilla VALUES('31','0');
INSERT INTO preg_plantilla VALUES('1','1');
INSERT INTO preg_plantilla VALUES('2','2');
INSERT INTO preg_plantilla VALUES('5','3');
INSERT INTO preg_plantilla VALUES('6','0');
INSERT INTO preg_plantilla VALUES('35','1');
INSERT INTO preg_plantilla VALUES('32','2');
INSERT INTO preg_plantilla VALUES('22','0');
INSERT INTO preg_plantilla VALUES('22','1');
INSERT INTO preg_plantilla VALUES('22','2');
INSERT INTO preg_plantilla VALUES('22','3');
INSERT INTO preg_plantilla VALUES('31','0');
INSERT INTO preg_plantilla VALUES('3','1');
INSERT INTO preg_plantilla VALUES('4','2');
INSERT INTO preg_plantilla VALUES('6','3');
INSERT INTO preg_plantilla VALUES('10','0');
INSERT INTO preg_plantilla VALUES('34','1');
INSERT INTO preg_plantilla VALUES('35','2');
INSERT INTO preg_plantilla VALUES('36','2');
INSERT INTO preg_plantilla VALUES('37','0');
INSERT INTO preg_plantilla VALUES('37','1');
INSERT INTO preg_plantilla VALUES('37','2');
INSERT INTO preg_plantilla VALUES('37','3');
INSERT INTO preg_plantilla VALUES('38','0');
INSERT INTO preg_plantilla VALUES('39','0');
INSERT INTO preg_plantilla VALUES('40','0');
INSERT INTO preg_plantilla VALUES('41','0');
INSERT INTO preg_plantilla VALUES('42','0');
INSERT INTO preg_plantilla VALUES('43','0');
CREATE TABLE `preg_tipo` (`id_tipoinsti` tinyint(3) unsigned NOT NULL default '0',`id_preg` bigint(20) unsigned NOT NULL default '0',KEY `id_tipoinsti` (`id_tipoinsti`),KEY `id_preg` (`id_preg`)) TYPE=InnoDB;
INSERT INTO preg_tipo VALUES('0','1');
INSERT INTO preg_tipo VALUES('1','1');
INSERT INTO preg_tipo VALUES('2','1');
INSERT INTO preg_tipo VALUES('3','1');
INSERT INTO preg_tipo VALUES('0','2');
INSERT INTO preg_tipo VALUES('1','2');
INSERT INTO preg_tipo VALUES('2','2');
INSERT INTO preg_tipo VALUES('3','2');
INSERT INTO preg_tipo VALUES('0','3');
INSERT INTO preg_tipo VALUES('1','3');
INSERT INTO preg_tipo VALUES('2','3');
INSERT INTO preg_tipo VALUES('3','3');
INSERT INTO preg_tipo VALUES('0','4');
INSERT INTO preg_tipo VALUES('0','5');
INSERT INTO preg_tipo VALUES('1','5');
INSERT INTO preg_tipo VALUES('2','5');
INSERT INTO preg_tipo VALUES('3','5');
INSERT INTO preg_tipo VALUES('0','6');
INSERT INTO preg_tipo VALUES('1','6');
INSERT INTO preg_tipo VALUES('2','6');
INSERT INTO preg_tipo VALUES('3','6');
INSERT INTO preg_tipo VALUES('0','7');
INSERT INTO preg_tipo VALUES('1','7');
INSERT INTO preg_tipo VALUES('2','7');
INSERT INTO preg_tipo VALUES('3','7');
INSERT INTO preg_tipo VALUES('0','8');
INSERT INTO preg_tipo VALUES('1','8');
INSERT INTO preg_tipo VALUES('2','8');
INSERT INTO preg_tipo VALUES('3','8');
INSERT INTO preg_tipo VALUES('0','9');
INSERT INTO preg_tipo VALUES('1','9');
INSERT INTO preg_tipo VALUES('2','9');
INSERT INTO preg_tipo VALUES('3','9');
INSERT INTO preg_tipo VALUES('0','10');
INSERT INTO preg_tipo VALUES('1','10');
INSERT INTO preg_tipo VALUES('3','10');
INSERT INTO preg_tipo VALUES('0','11');
INSERT INTO preg_tipo VALUES('0','12');
INSERT INTO preg_tipo VALUES('1','12');
INSERT INTO preg_tipo VALUES('2','12');
INSERT INTO preg_tipo VALUES('3','12');
INSERT INTO preg_tipo VALUES('0','13');
INSERT INTO preg_tipo VALUES('0','14');
INSERT INTO preg_tipo VALUES('0','15');
INSERT INTO preg_tipo VALUES('0','16');
INSERT INTO preg_tipo VALUES('1','16');
INSERT INTO preg_tipo VALUES('2','16');
INSERT INTO preg_tipo VALUES('3','16');
INSERT INTO preg_tipo VALUES('0','17');
INSERT INTO preg_tipo VALUES('1','17');
INSERT INTO preg_tipo VALUES('2','17');
INSERT INTO preg_tipo VALUES('3','17');
INSERT INTO preg_tipo VALUES('0','18');
INSERT INTO preg_tipo VALUES('1','18');
INSERT INTO preg_tipo VALUES('2','18');
INSERT INTO preg_tipo VALUES('3','18');
INSERT INTO preg_tipo VALUES('2','19');
INSERT INTO preg_tipo VALUES('2','20');
INSERT INTO preg_tipo VALUES('2','21');
INSERT INTO preg_tipo VALUES('0','23');
INSERT INTO preg_tipo VALUES('1','23');
INSERT INTO preg_tipo VALUES('2','23');
INSERT INTO preg_tipo VALUES('3','23');
INSERT INTO preg_tipo VALUES('3','24');
INSERT INTO preg_tipo VALUES('3','25');
INSERT INTO preg_tipo VALUES('3','26');
INSERT INTO preg_tipo VALUES('1','27');
INSERT INTO preg_tipo VALUES('1','28');
INSERT INTO preg_tipo VALUES('1','29');
INSERT INTO preg_tipo VALUES('1','30');
INSERT INTO preg_tipo VALUES('0','31');
INSERT INTO preg_tipo VALUES('1','31');
INSERT INTO preg_tipo VALUES('2','31');
INSERT INTO preg_tipo VALUES('3','31');
INSERT INTO preg_tipo VALUES('0','32');
INSERT INTO preg_tipo VALUES('1','32');
INSERT INTO preg_tipo VALUES('2','32');
INSERT INTO preg_tipo VALUES('3','32');
INSERT INTO preg_tipo VALUES('0','33');
INSERT INTO preg_tipo VALUES('1','33');
INSERT INTO preg_tipo VALUES('2','33');
INSERT INTO preg_tipo VALUES('3','33');
INSERT INTO preg_tipo VALUES('0','34');
INSERT INTO preg_tipo VALUES('1','34');
INSERT INTO preg_tipo VALUES('2','34');
INSERT INTO preg_tipo VALUES('3','34');
INSERT INTO preg_tipo VALUES('0','35');
INSERT INTO preg_tipo VALUES('1','35');
INSERT INTO preg_tipo VALUES('2','35');
INSERT INTO preg_tipo VALUES('3','35');
INSERT INTO preg_tipo VALUES('0','22');
INSERT INTO preg_tipo VALUES('1','22');
INSERT INTO preg_tipo VALUES('2','22');
INSERT INTO preg_tipo VALUES('3','22');
INSERT INTO preg_tipo VALUES('2','36');
INSERT INTO preg_tipo VALUES('0','37');
INSERT INTO preg_tipo VALUES('1','37');
INSERT INTO preg_tipo VALUES('2','37');
INSERT INTO preg_tipo VALUES('3','37');
INSERT INTO preg_tipo VALUES('0','38');
INSERT INTO preg_tipo VALUES('0','39');
INSERT INTO preg_tipo VALUES('0','40');
INSERT INTO preg_tipo VALUES('0','41');
INSERT INTO preg_tipo VALUES('0','42');
INSERT INTO preg_tipo VALUES('0','43');
CREATE TABLE `pregunta` (`id_preg` bigint(20) unsigned NOT NULL default '0',`tex_preg` text NOT NULL,`id_categoria` tinyint(3) unsigned NOT NULL default '0',`criterio` text NOT NULL,PRIMARY KEY  (`id_preg`),KEY `id_categoria` (`id_categoria`)) TYPE=InnoDB;
INSERT INTO pregunta VALUES('1','Solicite y revise los diagramas Entidad-Relacin de los sistemas de informacin que utilice la entidad.','2','');
INSERT INTO pregunta VALUES('2','Solicite y revise el manual de usuario de los sistemas de informacin que utilice la entidad.','2','');
INSERT INTO pregunta VALUES('3','Solicite y revise el diccionario de datos de los sistemas informticos de la entidad.','2','');
INSERT INTO pregunta VALUES('4','Solicite y revise que la descripcin de los mdulos de los sistemas de informacin sean de conformidad al manual contable de Almacenes Generales de Depsito.  ','2','');
INSERT INTO pregunta VALUES('5','Solicite y revise que exista un plan de trabajo para la implementacin de los sistemas informticos.','3','');
INSERT INTO pregunta VALUES('6','Solicite y revise los procesos de flujo de informacin.','3','');
INSERT INTO pregunta VALUES('7','Solicite y revise el proceso para generar reportes.','2','');
INSERT INTO pregunta VALUES('8','Solicite acceso a la base de datos y verifique la  actualizacin de las tablas graficadas en los diagramas  Entidad - Relacin de los  sistemas.','2','');
INSERT INTO pregunta VALUES('9','Verifique el proceso de la entrada y salida de datos.','2','');
INSERT INTO pregunta VALUES('10','Verifique que la ejecucin de las operaciones estn registradas en la base de datos segn los  horarios autorizados por la Junta Directiva de la entidad.



','3','');
INSERT INTO pregunta VALUES('11','Compruebe que los cambios efectuados a las operaciones

contables estn registrados en bitcoras de control de

cambios.','2','');
INSERT INTO pregunta VALUES('12','Solicite un listado de los usuarios de los sistemas y compruebe que los roles definidos en la base de datos corresponda a las funciones y asignaciones de estos.','2','');
INSERT INTO pregunta VALUES('13','Compruebe la consistencia de la informacin de la emisin del certificado de depsito y del bono de prenda,  registrada en la base de datos, tales como: Lugar y fecha del depsito, Plazo fijo sealado para el deposito, tipo de designacin, relacin de los bienes depositados calidad, cantidad, valor aproximado, nombre de la persona a cuyo favor se expide, indicacin del importe en que han sido aseguradas las mercancas etc.','2','');
INSERT INTO pregunta VALUES('14','Compruebe que el sistema y la informacin de la base de datos cumpla con las siguientes validaciones:

a)Que el catlogo de cuentas est actualizado de conformidad al manual contable de Almacenes Generales de Depsito.

b)Que las empresas registradas estn activas.','2','');
INSERT INTO pregunta VALUES('15','Verifique si existen cuentas anuladas y si existe Documentacin que respalda el proceso de anulacin.','2','');
INSERT INTO pregunta VALUES('16','Solicite una conexin directa a la base de datos, para efectos de realizar la auditora de sistemas.','2','');
INSERT INTO pregunta VALUES('17','Compare la informacin que contiene el diagrama de Entidad - Relacin y el Diccionario de Datos y compruebe en la base de datos si stos estn actualizados.','2','');
INSERT INTO pregunta VALUES('18','Verifique que los datos que contiene la tabla Maestro de Clientes estn actualizados.','2','');
INSERT INTO pregunta VALUES('19','Revise los antecedentes de la Casa y verifique si se han determinado observaciones en la operatividad.','3','');
INSERT INTO pregunta VALUES('20','Verifique que los manuales aprobados por la Superintendencia de Valores estn siendo utilizados.','3','');
INSERT INTO pregunta VALUES('21','Verifique si la informacin de los contratos est de acuerdo a lo aprobado por la 

Superintendencia, y que la informacin que se ingrese en las tablas de clientes sea segn lo establecido en el contrato con cada cliente, el cual debe aparecer en el expediente.','3','');
INSERT INTO pregunta VALUES('22','Solicite y revise el inventario de los usuarios que tienen acceso a los sistemas que posee la entidad','2','');
INSERT INTO pregunta VALUES('23','Explore el sistema usando como referencia el manual de usuario para comprobar si est actualizado.','2','');
INSERT INTO pregunta VALUES('24','Verifique que el sistema de CEDEVAL tiene un mdulo para el Registro Electrnico de Cuentas de Valores.','2','');
INSERT INTO pregunta VALUES('25','Compruebe que las fechas de vencimiento de reporto se registran en el sistema.','2','');
INSERT INTO pregunta VALUES('26','Verifique que CEDEVAL tenga un sistema para el registro Electrnico de Depsito de Emisiones que documente las emisiones depositadas.','2','');
INSERT INTO pregunta VALUES('27','Solicite las reglas operativas del Sistema Electrnico de 

negociacin y verifique su cumplimiento con la practica de negociacin. ','2','');
INSERT INTO pregunta VALUES('28','Verifique que las operaciones en el Sistema Electrnico de Negociacin estn identificadas con el color distinto para cada mercado segn lo define el manual de operacin burstil.','2','');
INSERT INTO pregunta VALUES('29','Compruebe que las frmulas de precios y rendimientos utilizados por el sistema sean segn las frmulas establecidas en el manual de operatividad burstil.','2','');
INSERT INTO pregunta VALUES('30','Compruebe en el sistema de liquidacin, que los registros almacenados en la base de datos, cumplen con lo establecido en el manual de operatividad burstil.','2','');
INSERT INTO pregunta VALUES('31','Solicite el inventario del Hardware que pertenece a la entidad.','1','');
INSERT INTO pregunta VALUES('32','Solicite el programa de seguridad de la entidad y verifique si est actualizado.','6','');
INSERT INTO pregunta VALUES('33','Verifique si la entidad tiene un plan de contingencia anti-desastres.','6','');
INSERT INTO pregunta VALUES('34','Verifique las polticas de administracin de las cuentas de usuario de las bases de datos.','4','');
INSERT INTO pregunta VALUES('35','Verifique si existen polticas de administracin de contraseas de usuario.','5','');
INSERT INTO pregunta VALUES('36','es el software de la casa legal','2','');
INSERT INTO pregunta VALUES('37','se planean las inversiones','0','');
INSERT INTO pregunta VALUES('38','se precisan los informes','0','');
INSERT INTO pregunta VALUES('39','asfdasdf','0','');
INSERT INTO pregunta VALUES('40','esto es un ejemplo','0','');
INSERT INTO pregunta VALUES('41','esto es otro ejemplo','0','');
INSERT INTO pregunta VALUES('42','cosas nuevas','0','');
INSERT INTO pregunta VALUES('43','pregunta nueva','1','');
CREATE TABLE `rol` (`id_rol` tinyint(3) unsigned NOT NULL default '0',`tipo_rol` enum('admin','ope','consul') NOT NULL default 'admin',PRIMARY KEY  (`id_rol`),UNIQUE KEY `tipo_rol` (`tipo_rol`)) TYPE=InnoDB;
INSERT INTO rol VALUES('0','admin');
INSERT INTO rol VALUES('2','ope');
INSERT INTO rol VALUES('1','consul');
CREATE TABLE `tipo_institucion` (`id_tipoinsti` tinyint(3) unsigned NOT NULL default '0',`nom_tipo` varchar(20) NOT NULL default '',PRIMARY KEY  (`id_tipoinsti`),UNIQUE KEY `nom_tipo` (`nom_tipo`)) TYPE=InnoDB;
INSERT INTO tipo_institucion VALUES('0','Almacen');
INSERT INTO tipo_institucion VALUES('1','Bolsa de Valores');
INSERT INTO tipo_institucion VALUES('2','Casa Corredora');
INSERT INTO tipo_institucion VALUES('3','CEDEVAL');
CREATE TABLE `usu_papel` (`id_usu` int(10) unsigned NOT NULL default '0',`id_papel` bigint(20) unsigned NOT NULL default '0',KEY `id_usu` (`id_usu`),KEY `id_papel` (`id_papel`)) TYPE=InnoDB;
INSERT INTO usu_papel VALUES('2','1');
CREATE TABLE `usuario` (`id_usu` int(10) unsigned NOT NULL default '0',`ape_usu` varchar(30) NOT NULL default '',`nom_usu` varchar(30) NOT NULL default '',`cargo_usu` varchar(20) NOT NULL default '',`login` varchar(12) NOT NULL default '',`passw` varchar(12) NOT NULL default '',`id_rol` tinyint(3) unsigned NOT NULL default '0',`bloqueado` tinyint(11) NOT NULL default '0',PRIMARY KEY  (`id_usu`),UNIQUE KEY `login` (`login`),UNIQUE KEY `passw` (`passw`),KEY `id_rol` (`id_rol`)) TYPE=InnoDB;
INSERT INTO usuario VALUES('0','General','General','ninguno','sa','sap','0','0');
INSERT INTO usuario VALUES('1','Pineda','Rosita','Auditora','rpineda1','rpineda1','0','0');
INSERT INTO usuario VALUES('2','Bolaos','joaquin','programador','jbolanos','jbolanos','2','0');
INSERT INTO usuario VALUES('3','lopez','juan','contador','juanjuan','juanjuan','1','0');
ALTER TABLE `categoria` ADD CONSTRAINT `categoria_ibfk_1` FOREIGN KEY (`id_ced`) REFERENCES `cedula` (`id_ced`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `contacto`  ADD CONSTRAINT `contacto_ibfk_1` FOREIGN KEY (`id_insti`) REFERENCES `institucion` (`id_insti`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `historial` ADD CONSTRAINT `historial_ibfk_1` FOREIGN KEY (`id_usu`) REFERENCES `usuario` (`id_usu`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT `historial_ibfk_2` FOREIGN KEY (`id_actividad`) REFERENCES `actividad` (`id_actividad`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `institucion` ADD CONSTRAINT `institucion_ibfk_1` FOREIGN KEY (`id_tipoinsti`) REFERENCES `tipo_institucion` (`id_tipoinsti`) ON UPDATE CASCADE;
ALTER TABLE `papel_de_trabajo` ADD CONSTRAINT `papel_de_trabajo_ibfk_1` FOREIGN KEY (`id_insti`) REFERENCES `institucion` (`id_insti`) ON UPDATE CASCADE, ADD CONSTRAINT `papel_de_trabajo_ibfk_2` FOREIGN KEY (`id_plantilla`) REFERENCES `plantilla` (`id_plantilla`) ON UPDATE CASCADE;
ALTER TABLE `plantilla` ADD CONSTRAINT `plantilla_ibfk_1` FOREIGN KEY (`id_usu`) REFERENCES `usuario` (`id_usu`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `preg_papel` ADD CONSTRAINT `preg_papel_ibfk_1` FOREIGN KEY (`id_preg`) REFERENCES `pregunta` (`id_preg`) ON UPDATE CASCADE, ADD CONSTRAINT `preg_papel_ibfk_2` FOREIGN KEY (`id_papel`) REFERENCES `papel_de_trabajo` (`id_papel`) ON UPDATE CASCADE;
ALTER TABLE `preg_plantilla` ADD CONSTRAINT `preg_plantilla_ibfk_1` FOREIGN KEY (`id_preg`) REFERENCES `pregunta` (`id_preg`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `preg_plantilla_ibfk_2` FOREIGN KEY (`id_plantilla`) REFERENCES `plantilla` (`id_plantilla`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `preg_tipo` ADD CONSTRAINT `preg_tipo_ibfk_1` FOREIGN KEY (`id_tipoinsti`) REFERENCES `tipo_institucion` (`id_tipoinsti`) ON UPDATE CASCADE, ADD CONSTRAINT `preg_tipo_ibfk_2` FOREIGN KEY (`id_preg`) REFERENCES `pregunta` (`id_preg`) ON UPDATE CASCADE;
ALTER TABLE `pregunta` ADD CONSTRAINT `pregunta_ibfk_1` FOREIGN KEY (`id_categoria`) REFERENCES `categoria` (`id_categoria`) ON UPDATE CASCADE;
ALTER TABLE `usu_papel` ADD CONSTRAINT `usu_papel_ibfk_1` FOREIGN KEY (`id_usu`) REFERENCES `usuario` (`id_usu`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `usu_papel_ibfk_2` FOREIGN KEY (`id_papel`) REFERENCES `papel_de_trabajo` (`id_papel`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `usuario` ADD CONSTRAINT `usuario_ibfk_1` FOREIGN KEY (`id_rol`) REFERENCES `rol` (`id_rol`) ON DELETE CASCADE ON UPDATE CASCADE;